Occurs when a field is edited either programmatically or by a user.
Syntax
Private Sub object_DataUpdate(cancel As boolean, ByVal Record As Variant, ByVal field As String)
The DataUpdate event syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
cancel | A Boolean value that specifies if the operation is canceled. |
record | A Variant array that contains the bookmark of the current record. |
field | A string that indicates the name of the field which is about to change. |
Remarks
The field argument does not have to be a bound field. If any field in the recordset is changed, the event will occur.